ODBC

The first of these nodes, ODBC, shows a list of ODBC data sources that you have already configured for use. These are local and remote data sources that are not accessed through an object model such as ADO or DAO. The Report Designer Component can use the same database drivers for these data sources that are available through Crystal Reports.

Note:    To use these drivers, you must install the full Crystal Reports product.

You can either use an existing data source or create a new one by selecting the Create New Data Source option. If you select, Create New Data Source, the RDC displays a Wizard that leads you through the creation process.

You will need to supply:

If you are setting up a machine-independent File Data Source, you will also be asked to supply the name of the file data source you want to save the connection to.

Once you've supplied this information, the Wizard sets up the data source for you.

To connect to an existing ODBC data source
  1. Choose the data source.
  2. Choose the table(s) that contain the data you want to use.
  3. Link the tables (if required) using the Visual Linking Expert.

Once you have done this, the RDC lists the tables you have selected and the fields available in each table under the Database Fields node in the Field Explorer on the left side of the Designer.

Then drag the fields you want onto your report and position them where you want them.

Database Files

This node lists standard PC data sources that reside locally. If your database isn't listed, browse for your file using the Find Database File option.

More Data Sources

Use the More Data Sources node to select data sources that can be accessed through OLE DB and native drivers. This includes:



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com